package com.yuanchu.store.dao;

import com.yuanchu.store.entity.YoshopRechargeOrderEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 会员充值订单表
 * 
 * @author adan
 * @email 2028038953@gmail.com
 * @date 2023-12-19 20:57:23
 */
@Mapper
public interface YoshopRechargeOrderDao extends BaseMapper<YoshopRechargeOrderEntity> {
    @Select("SELECT SUM(pay_price) FROM yoshop2_db.yoshop_recharge_order where pay_status = 20")
    String rechargeMoney();
}
